﻿<?php include("conn.php") ?>
<!DOCTYPE HTML>
<html>
<head>
    <meta charset="utf-8">
    <meta name="renderer" content="webkit|ie-comp|ie-stand">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no" />
    <meta http-equiv="Cache-Control" content="no-siteapp" />
    <?php include("public/cssjs.php");?>
    <title>订单列表</title>
</head>
<body>
<nav class="breadcrumb"><i class="Hui-iconfont">&#xe67f;</i> 首页 <span class="c-gray en">&gt;</span> 订单管理 <span class="c-gray en">&gt;</span> 订单列表 <a class="btn btn-success radius r" style="line-height:1.6em;margin-top:3px" href="javascript:location.replace(location.href);" title="刷新" ><i class="Hui-iconfont">&#xe68f;</i></a></nav>
<div class="page-container">
    <form name="frmtj" method="get" action="?" style="margin-bottom: 10px">
        <div class="text-c" style="background: #ebebeb"> 日期范围：
            <input type="text" onfocus="WdatePicker({ maxDate:'#F{$dp.$D(\'logmax\')||\'%y-%M-%d\'}' })" id="logmin" name="logmin" class="input-text Wdate" style="width:120px;">
            -
            <input type="text" onfocus="WdatePicker({ minDate:'#F{$dp.$D(\'logmin\')}',maxDate:'%y-%M-%d' })" id="logmax" name="logmax" class="input-text Wdate" style="width:120px;">
            <span class="select-box" style=" width: 150px"> <select name="pstate" style="width: 140px" class="select" ><option value="">=支付状态=</option><option value="">全部</option><option value="0">未支付</option><option value="1">已支付</option></select></span>
            <input type="text" name="keyword" id="" placeholder="（订单/产品/员工/客户）编号" style="width:250px" class="input-text">
            <button name="" id="" class="btn btn-success" type="submit"><i class="Hui-iconfont">&#xe665;</i> 搜订单</button>
        </div>
    </form>
    <?php

    $keyword=$_GET["keyword"];
    $logmin=$_GET["logmin"];
    $logmax=$_GET["logmax"];
    $pstate=$_GET["pstate"];
    echo $pstate;
    if($pstate!=""){
        $cond=" o_paystate=".$pstate;
       }else{ $cond=" 1=1 "; }
    if($keyword!=""){ $cond.=" and o_formid like '%".$keyword."%' or o_pid like '%".$keyword."%' or o_wid like '%".$keyword."%' or o_gid like '%".$keyword."%'";}
    if($logmin!=""){ $cond.=" and adate>='".$logmin."'";}
    if($logmax!=""){ $cond.=" and adate<='".$logmax."'";}
    $conn=new Mysql();
    $sql = "select * from d_order where  $cond order by id desc";
    $page_size = 10;					 //定义每页显示多少记录
    $num_cnt = mysqli_num_rows($conn->query($sql)); //获取总记录数
    $page_cnt = ceil($num_cnt/$page_size);  //计算总页数
    if(isset($_GET["page"])){
        $page = intval($_GET["page"]);
    }else{
        $page = 1;
    }
    if ($page<1)
    {
        $page=1;
    }
    elseif ($page>$page_cnt)
    {
        $page=$page_cnt;
    }
    $query_start = ($page - 1 ) * $page_size;   //计算每页开始的记录号
    $query_sql = $sql." limit $query_start,$page_size"; //使用limit获取记录
    //echo $query_sql;
    //$query_set = $conn->getAll($query_sql);
    ?>
    <table class="table table-border table-bordered table-bg">
        <thead>
        <tr>
            <th scope="col" colspan="11">订单列表</th>
        </tr>
        <tr class="text-c">
            <th width="25"><input type="checkbox" name="" value=""></th>
            <th width="40">ID</th>
            <th  width="120">订单编号</th>
            <th width="90">产品名称</th>
            <th width="90">金额</th>
            <th width="110">客户昵称</th>
            <th width="110">打赏员工</th>
            <th width="60">交易状态</th>
            <th width="60">当前状态</th>
            <th width="130">加入时间</th>
            <th width="100">操作</th>
        </tr>
        </thead>
        <tbody>

        <?
        if($num_cnt>0)
        {
            $row=$conn->getAll($query_sql);
            foreach($row as $key=>$rs){
                ?>

                <tr class="text-c">
                    <td>

                        <input type="checkbox" value="<?php echo $rs["id"]; ?>" name="chkdel"></td>
                    <td><?php echo $rs["id"]; ?></td>
                    <td style="font-size:14px; font-family: Arial; font-weight: bold"><?php echo $rs["o_formid"]; ?></td>
                    <td><?php
                        $cona=new Mysql();
                        $row=$cona->getRow("select * from d_product where id=".$rs["o_pid"]);
                        echo $row["p_name"]."<font color=\"#27c916\">(ID:".$rs["o_pid"].")</font>";;
                         ?></td>
                    <td>&yen <font color="#ff0000"><?php echo $rs["o_price"]; ?></font> </td>
                    <td><?php
                        $cona=new Mysql();
                        $row=$cona->getRow("select * from d_guest where id=".$rs["o_gid"]);
                        echo $row["g_name"]."<font color=\"#f6912f\">(ID:".$rs["o_gid"].")</font>";
                        ?></td>
                    <td><?php
                        $cona=new Mysql();
                        $row=$cona->getRow("select * from d_worker where id=".$rs["o_wid"]);
                        echo $row["w_name"]."<font color=\"#3168e4\">(ID:".$rs["o_wid"].")</font>";
                        ?></td>
                    <td><?php if ($rs["o_paystate"] == 1) {
                            echo ' <span class="label label-danger">已支付</span>';
                        } else {
                            echo ' <span class="label label-info">未支付</span>';
                        } ?></td>
                    <td> <?php if ($rs["istate"] == 1) {
                            echo ' <span class="label label-success radius">已审核</span>';
                        } else {
                            echo ' <span class="label label-default radius">未审核</span>';
                        } ?></td>
                    <td><?php echo date("Y-m-d H:i:s", strtotime($rs["adate"])); ?></td>

                    <td class="td-manage">
                        <?php if ($rs["istate"] == 1) {
                            ?>
                            <a style="text-decoration:none" onClick="admin_stop(this,'<?php echo $rs["id"]; ?>')" href="javascript:;"
                               title="未审核"><i class="Hui-iconfont">&#xe631;</i></a>
                            <?
                        } else {
                            ?>
                            <a style="text-decoration:none" onClick="admin_start(this,'<?php echo $rs["id"]; ?>')" href="javascript:;"
                               title="已审核"><i class="Hui-iconfont">&#xe615;</i></a>
                            <?
                        } ?>

                        <a title="删除" href="javascript:;" onclick="admin_del(this,'<?php echo $rs["id"] ;?>')" class="ml-5"
                           style="text-decoration:none"><i class="Hui-iconfont">&#xe6e2;</i></a>

                    </td>
                </tr>
                <?
            }
            ?>
            <Tr><Td colspan="11"><?php Controlnews($num_cnt,$page_cnt,$page,$table_style,$font_style);?></Td></Tr>

            <?
        }else{
            ?>
            <Tr><Td colspan="11" align="center">暂无订单信息</Td></Tr>
            <?
        }
        ?>


        </tbody>
    </table>
</div>
<!--_footer 作为公共模版分离出去-->
<script type="text/javascript" src="lib/jquery/1.9.1/jquery.min.js"></script>
<script type="text/javascript" src="lib/layer/2.4/layer.js"></script>
<script type="text/javascript" src="static/h-ui/js/h-ui.min.js"></script>
<script type="text/javascript" src="static/h-ui.admin/js/h-ui.admin.js"></script> <!--/_footer 作为公共模版分离出去-->

<!--请在下方写此页面业务相关的脚本-->
<script type="text/javascript" src="lib/My97DatePicker/4.8/WdatePicker.js"></script>
<script type="text/javascript" src="lib/datatables/1.10.0/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="lib/laypage/1.2/laypage.js"></script>
<script type="text/javascript">
    /*
        参数解释：
        title	标题
        url		请求的url
        id		需要操作的数据id
        w		弹出层宽度（缺省调默认值）
        h		弹出层高度（缺省调默认值）
    */

    /*-删除*/
    function admin_del(obj,id){
        layer.confirm('确认要删除吗？',function(index){

            $.ajax({
                type: 'POST',
                url: 'json/orders.php',
                data:{'Type':'delete','id':id},
                dataType: 'json',
                success: function(data){
                    $(obj).parents("tr").remove();
                    layer.msg('已删除!',{icon:1,time:1000});
                },
                error:function(data) {
                    console.log(data.msg);
                },
            });
        });
    }

    /*-编辑*/
    function admin_edit(title,url,id,w,h){
        layer_show(title,url,w,h);
    }
    /*-停用*/
    function admin_stop(obj,id){
        layer.confirm('确认要停用吗？',function(index){
            //此处请求后台程序，下方是成功后的前台处理……
            $.ajax({
                type: 'POST',
                url: 'json/orders.php',
                data:{'Type':'checkstate','isstate':0,'id':id},
                dataType: 'json',
                success: function(data){

                    $(obj).parents("tr").find(".td-manage").prepend('<a onClick="admin_start(this,id)" href="javascript:;" title="启用" style="text-decoration:none"><i class="Hui-iconfont">&#xe615;</i></a>');
                    $(obj).parents("tr").find(".td-status").html('<span class="label label-default radius">已禁用</span>');
                    $(obj).remove();
                    layer.msg('已停用!',{icon: 5,time:1000});
                },
                error:function(data) {
                    console.log(data.msg);
                },
            });

        });
    }

    /*-启用*/
    function admin_start(obj,id){
        layer.confirm('确认要启用吗？',function(index){
            //此处请求后台程序，下方是成功后的前台处理……

            $.ajax({
                type: 'POST',
                url: 'json/orders.php',
                data:{'Type':'checkstate','isstate':1,'id':id},
                dataType: 'json',
                success: function(data){
                    $(obj).parents("tr").find(".td-manage").prepend('<a onClick="admin_stop(this,id)" href="javascript:;" title="停用" style="text-decoration:none"><i class="Hui-iconfont">&#xe631;</i></a>');
                    $(obj).parents("tr").find(".td-status").html('<span class="label label-success radius">已启用</span>');
                    $(obj).remove();
                    layer.msg('已启用!', {icon: 6,time:1000});
                },
                error:function(data) {
                    console.log(data.msg);
                },
            });

        });
    }
</script>
</body>
</html>